package QuanLyNhanSu;
import java.sql.*;
public class connectODBC{
  public static void main (String []argv)  {
        String conStr = "jdbc:odbc:qltk";
        Connection con; 
        try{
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
           con = DriverManager.getConnection(conStr,"","");
           Statement stmt = con.createStatement();
           int rs =stmt.executeUpdate("delete * from accounts where CustomerID = '333333'");
           System.out.println(rs);/*if (rs != null)
        	   while (rs.next()){
        		   System.out.print(rs.getString("CustomerID") + "\t");
        		   System.out.print(rs.getString("FullName") + "\t");
        		   System.out.print(rs.getString("IDCard") + "\t");
        		   System.out.println(rs.getString("Address"));
        		   //if (str.charAt(0) == 'B')
        			 //  rs.deleteRow();
        	   }
		rs.close();*/
		stmt.close();
		con.close();
	    } catch(Exception e) {
	    	System.out.println("Error : "+e); 
	    }
   }
}
